Profiling Report

Dataset statistics

Number of variables	16
Number of observations	1296675
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	123.7 MiB
Average record size in memory	100.0 B

Variable types

Numeric	14
Categorical	2

Alerts

`lat` is highly overall correlated with `merch_lat`	High correlation
`long` is highly overall correlated with `merch_long` and 1 other fields	High correlation
`merch_lat` is highly overall correlated with `lat`	High correlation
`merch_long` is highly overall correlated with `long` and 1 other fields	High correlation
`trans_date_trans_time` is highly overall correlated with `unix_time`	High correlation
`unix_time` is highly overall correlated with `trans_date_trans_time`	High correlation
`zip` is highly overall correlated with `long` and 1 other fields	High correlation
`is_fraud` is highly imbalanced (94.9%)	Imbalance
`amt` is highly skewed (γ1 = 42.27787379)	Skewed
`trans_date_trans_time` is uniformly distributed	Uniform
`trans_num` is uniformly distributed	Uniform
`trans_num` has unique values	Unique
`category` has 94014 (7.3%) zeros	Zeros

Reproduction

Analysis started	2024-09-15 11:15:33.219358
Analysis finished	2024-09-15 11:16:59.923092
Duration	1 minute and 26.7 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

trans_date_trans_time
Real number (ℝ)

HIGH CORRELATION UNIFORM

Distinct	1274791
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	637735.05

Minimum	0
Maximum	1274790
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	64078.7
Q1	319473.5
median	638093
Q3	955484.5
95-th percentile	1211123.3
Maximum	1274790
Range	1274790
Interquartile range (IQR)	636011

Descriptive statistics

Standard deviation	367716.4
Coefficient of variation (CV)	0.57659745
Kurtosis	-1.1981127
Mean	637735.05
Median Absolute Deviation (MAD)	318013
Skewness	-0.0010780392
Sum	8.2693509 × 10¹¹
Variance	1.3521535 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219657	4	< 0.1%
1218320	4	< 0.1%
1223720	4	< 0.1%
743811	3	< 0.1%
774485	3	< 0.1%
812260	3	< 0.1%
899009	3	< 0.1%
1254673	3	< 0.1%
567996	3	< 0.1%
416086	3	< 0.1%
Other values (1274781)	1296642	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
1274790	1	< 0.1%
1274789	1	< 0.1%
1274788	1	< 0.1%
1274787	1	< 0.1%
1274786	1	< 0.1%
1274785	1	< 0.1%
1274784	1	< 0.1%
1274783	1	< 0.1%
1274782	1	< 0.1%
1274781	1	< 0.1%

cc_num
Real number (ℝ)

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1719204 × 10¹⁷

Minimum	6.0416207 × 10¹⁰
Maximum	4.9923464 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	6.0416207 × 10¹⁰
5-th percentile	6.3048488 × 10¹¹
Q1	1.8004295 × 10¹⁴
median	3.5214173 × 10¹⁵
Q3	4.6422555 × 10¹⁵
95-th percentile	4.497914 × 10¹⁸
Maximum	4.9923464 × 10¹⁸
Range	4.9923463 × 10¹⁸
Interquartile range (IQR)	4.4622125 × 10¹⁵

Descriptive statistics

Standard deviation	1.3088064 × 10¹⁸
Coefficient of variation (CV)	3.1371798
Kurtosis	6.1799499
Mean	4.1719204 × 10¹⁷
Median Absolute Deviation (MAD)	3.0764709 × 10¹⁵
Skewness	2.851879
Sum	-6.7255419 × 10¹⁸
Variance	1.7129743 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.713652351 × 10¹¹	3123	0.2%
4.512828415 × 10¹⁸	3123	0.2%
3.672269902 × 10¹³	3119	0.2%
2.131124026 × 10¹⁴	3117	0.2%
3.54510934 × 10¹⁵	3113	0.2%
6.534628261 × 10¹⁵	3112	0.2%
6.011367958 × 10¹⁵	3110	0.2%
2.720433096 × 10¹⁵	3107	0.2%
6.011438889 × 10¹⁵	3106	0.2%
6.011109737 × 10¹⁵	3101	0.2%
Other values (973)	1265544	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.041620718 × 10¹⁰	1518	0.1%
6.042292873 × 10¹⁰	1531	0.1%
6.042309813 × 10¹⁰	510	< 0.1%
6.042785159 × 10¹⁰	528	< 0.1%
6.048700208 × 10¹⁰	496	< 0.1%
6.04905963 × 10¹⁰	1010	0.1%
6.049559311 × 10¹⁰	518	< 0.1%
5.018029536 × 10¹¹	1559	0.1%
5.018181333 × 10¹¹	8	< 0.1%
5.018282048 × 10¹¹	515	< 0.1%

Value	Count	Frequency (%)
4.992346398 × 10¹⁸	2059	0.2%
4.989847571 × 10¹⁸	1007	0.1%
4.980323468 × 10¹⁸	532	< 0.1%
4.973530368 × 10¹⁸	1040	0.1%
4.958589672 × 10¹⁸	1476	0.1%
4.95682899 × 10¹⁸	2566	0.2%
4.911818931 × 10¹⁸	9	< 0.1%
4.906628656 × 10¹⁸	2584	0.2%
4.897067971 × 10¹⁸	1038	0.1%
4.890424427 × 10¹⁸	1496	0.1%

merchant
Real number (ℝ)

Distinct	693
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	342.85849

Minimum	0
Maximum	692
Zeros	1844
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	33
Q1	165
median	346
Q3	514
95-th percentile	659
Maximum	692
Range	692
Interquartile range (IQR)	349

Descriptive statistics

Standard deviation	200.9519
Coefficient of variation (CV)	0.58610739
Kurtosis	-1.215053
Mean	342.85849
Median Absolute Deviation (MAD)	175
Skewness	0.0086598641
Sum	4.4457604 × 10⁸
Variance	40381.666
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
316	4403	0.3%
105	3649	0.3%
571	3634	0.3%
349	3510	0.3%
70	3493	0.3%
136	3434	0.3%
117	2736	0.2%
358	2734	0.2%
463	2723	0.2%
607	2721	0.2%
Other values (683)	1263638	97.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1844	0.1%
1	1763	0.1%
2	1751	0.1%
3	1895	0.1%
4	940	0.1%
5	1746	0.1%
6	1904	0.1%
7	2503	0.2%
8	1923	0.1%
9	821	0.1%

Value	Count	Frequency (%)
692	1783	0.1%
691	2560	0.2%
690	1695	0.1%
689	1804	0.1%
688	1297	0.1%
687	2017	0.2%
686	1870	0.1%
685	1766	0.1%
684	1872	0.1%
683	2358	0.2%

category
Real number (ℝ)

ZEROS

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2277872

Minimum	0
Maximum	13
Zeros	94014
Zeros (%)	7.3%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	6
Q3	10
95-th percentile	12
Maximum	13
Range	13
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.9134428
Coefficient of variation (CV)	0.62838416
Kurtosis	-1.1947613
Mean	6.2277872
Median Absolute Deviation (MAD)	4
Skewness	0.04905729
Sum	8075416
Variance	15.315035
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2	131659	10.2%
4	123638	9.5%
6	123115	9.5%
12	116672	9.0%
7	113035	8.7%
11	97543	7.5%
0	94014	7.3%
1	91461	7.1%
10	90758	7.0%
5	85879	6.6%
Other values (4)	228901	17.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94014	7.3%
1	91461	7.1%
2	131659	10.2%
3	45452	3.5%
4	123638	9.5%
5	85879	6.6%
6	123115	9.5%
7	113035	8.7%
8	63287	4.9%
9	79655	6.1%

Value	Count	Frequency (%)
13	40507	3.1%
12	116672	9.0%
11	97543	7.5%
10	90758	7.0%
9	79655	6.1%
8	63287	4.9%
7	113035	8.7%
6	123115	9.5%
5	85879	6.6%
4	123638	9.5%

amt
Real number (ℝ)

SKEWED

Distinct	52928
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.351035

Minimum	1
Maximum	28948.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2.44
Q1	9.65
median	47.52
Q3	83.14
95-th percentile	196.31
Maximum	28948.9
Range	28947.9
Interquartile range (IQR)	73.49

Descriptive statistics

Standard deviation	160.31604
Coefficient of variation (CV)	2.2788014
Kurtosis	4545.645
Mean	70.351035
Median Absolute Deviation (MAD)	37.5
Skewness	42.277874
Sum	91222429
Variance	25701.232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.14	542	< 0.1%
1.04	538	< 0.1%
1.25	535	< 0.1%
1.02	533	< 0.1%
1.01	523	< 0.1%
1.05	519	< 0.1%
1.2	516	< 0.1%
1.23	515	< 0.1%
1.08	512	< 0.1%
1.11	509	< 0.1%
Other values (52918)	1291433	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	222	< 0.1%
1.01	523	< 0.1%
1.02	533	< 0.1%
1.03	499	< 0.1%
1.04	538	< 0.1%
1.05	519	< 0.1%
1.06	471	< 0.1%
1.07	498	< 0.1%
1.08	512	< 0.1%
1.09	496	< 0.1%

Value	Count	Frequency (%)
28948.9	1	< 0.1%
27390.12	1	< 0.1%
27119.77	1	< 0.1%
26544.12	1	< 0.1%
25086.94	1	< 0.1%
17897.24	1	< 0.1%
15305.95	1	< 0.1%
15047.03	1	< 0.1%
15034.18	1	< 0.1%
14849.74	1	< 0.1%

gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

0	709863
1	586812

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Most occurring characters

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1296675	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	1296675	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1296675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	709863	54.7%
1	586812	45.3%

street
Real number (ℝ)

Distinct	983
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	488.03441

Minimum	0
Maximum	982
Zeros	2602
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	48
Q1	252
median	485
Q3	720
95-th percentile	929
Maximum	982
Range	982
Interquartile range (IQR)	468

Descriptive statistics

Standard deviation	280.06084
Coefficient of variation (CV)	0.57385469
Kurtosis	-1.1723021
Mean	488.03441
Median Absolute Deviation (MAD)	235
Skewness	0.0082662276
Sum	6.3282202 × 10⁸
Variance	78434.073
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	3123	0.2%
859	3123	0.2%
814	3119	0.2%
472	3117	0.2%
805	3113	0.2%
303	3112	0.2%
160	3110	0.2%
848	3107	0.2%
417	3106	0.2%
601	3101	0.2%
Other values (973)	1265544	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2602	0.2%
1	1523	0.1%
2	972	0.1%
3	11	< 0.1%
4	1019	0.1%
5	1542	0.1%
6	3123	0.2%
7	524	< 0.1%
8	2032	0.2%
9	2036	0.2%

Value	Count	Frequency (%)
982	1035	0.1%
981	1022	0.1%
980	521	< 0.1%
979	504	< 0.1%
978	8	< 0.1%
977	2553	0.2%
976	1518	0.1%
975	2021	0.2%
974	998	0.1%
973	523	< 0.1%

city
Real number (ℝ)

Distinct	894
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	445.26328

Minimum	0
Maximum	893
Zeros	532
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	46
Q1	224
median	439
Q3	677
95-th percentile	843
Maximum	893
Range	893
Interquartile range (IQR)	453

Descriptive statistics

Standard deviation	258.60012
Coefficient of variation (CV)	0.58078024
Kurtosis	-1.2142164
Mean	445.26328
Median Absolute Deviation (MAD)	225
Skewness	0.0094241413
Sum	5.7736177 × 10⁸
Variance	66874.021
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74	5617	0.4%
725	5130	0.4%
821	5105	0.4%
644	5075	0.4%
501	5060	0.4%
796	4634	0.4%
171	4613	0.4%
154	4604	0.4%
837	4599	0.4%
359	4168	0.3%
Other values (884)	1248070	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	532	< 0.1%
1	2097	0.2%
2	516	< 0.1%
3	2035	0.2%
4	511	< 0.1%
5	1056	0.1%
6	1025	0.1%
7	1019	0.1%
8	1034	0.1%
9	1049	0.1%

Value	Count	Frequency (%)
893	1537	0.1%
892	1557	0.1%
891	525	< 0.1%
890	2109	0.2%
889	514	< 0.1%
888	511	< 0.1%
887	537	< 0.1%
886	1055	0.1%
885	1040	0.1%
884	11	< 0.1%

zip
Real number (ℝ)

HIGH CORRELATION

Distinct	970
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48800.671

Minimum	1257
Maximum	99783
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1257
5-th percentile	7208
Q1	26237
median	48174
Q3	72042
95-th percentile	94569
Maximum	99783
Range	98526
Interquartile range (IQR)	45805

Descriptive statistics

Standard deviation	26893.222
Coefficient of variation (CV)	0.55108305
Kurtosis	-1.0964493
Mean	48800.671
Median Absolute Deviation (MAD)	23068
Skewness	0.079680758
Sum	6.327861 × 10¹⁰
Variance	7.2324542 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73754	3646	0.3%
34112	3613	0.3%
48088	3597	0.3%
82514	3527	0.3%
49628	3123	0.2%
15484	3123	0.2%
85173	3119	0.2%
29819	3117	0.2%
38761	3113	0.2%
5461	3112	0.2%
Other values (960)	1263585	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1257	2023	0.2%
1330	1031	0.1%
1535	515	< 0.1%
1545	1024	0.1%
1612	519	< 0.1%
1843	2597	0.2%
1844	2058	0.2%
2180	519	< 0.1%
2630	2090	0.2%
2908	550	< 0.1%

Value	Count	Frequency (%)
99783	1568	0.1%
99747	12	< 0.1%
99746	540	< 0.1%
99323	2572	0.2%
99160	3030	0.2%
99116	15	< 0.1%
99113	1047	0.1%
99033	2458	0.2%
98836	524	< 0.1%
98665	500	< 0.1%

lat
Real number (ℝ)

HIGH CORRELATION

Distinct	968
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.537622

Minimum	20.0271
Maximum	66.6933
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	20.0271
5-th percentile	29.8826
Q1	34.6205
median	39.3543
Q3	41.9404
95-th percentile	45.8433
Maximum	66.6933
Range	46.6662
Interquartile range (IQR)	7.3199

Descriptive statistics

Standard deviation	5.0758084
Coefficient of variation (CV)	0.13171047
Kurtosis	0.81296795
Mean	38.537622
Median Absolute Deviation (MAD)	3.3597
Skewness	-0.18602768
Sum	49970771
Variance	25.763831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36.385	3646	0.3%
26.1184	3613	0.3%
42.5164	3597	0.3%
43.0048	3527	0.3%
39.8936	3123	0.2%
44.5995	3123	0.2%
33.2887	3119	0.2%
34.0326	3117	0.2%
33.4783	3113	0.2%
44.3346	3112	0.2%
Other values (958)	1263585	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20.0271	1527	0.1%
20.0827	1032	0.1%
24.6557	2584	0.2%
26.1184	3613	0.3%
26.3304	542	< 0.1%
26.3771	518	< 0.1%
26.4215	3038	0.2%
26.4722	2524	0.2%
26.529	1549	0.1%
26.6939	1027	0.1%

Value	Count	Frequency (%)
66.6933	12	< 0.1%
65.6899	540	< 0.1%
64.7556	1568	0.1%
48.8878	3030	0.2%
48.8856	2066	0.2%
48.8328	1533	0.1%
48.6669	1047	0.1%
48.6031	2973	0.2%
48.4786	2038	0.2%
48.34	3088	0.2%

long
Real number (ℝ)

HIGH CORRELATION

Distinct	969
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.226335

Minimum	-165.6723
Maximum	-67.9503
Zeros	0
Zeros (%)	0.0%
Negative	1296675
Negative (%)	100.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	-165.6723
5-th percentile	-119.0825
Q1	-96.798
median	-87.4769
Q3	-80.158
95-th percentile	-73.5112
Maximum	-67.9503
Range	97.722
Interquartile range (IQR)	16.64

Descriptive statistics

Standard deviation	13.759077
Coefficient of variation (CV)	-0.15249513
Kurtosis	1.8558923
Mean	-90.226335
Median Absolute Deviation (MAD)	8.1527
Skewness	-1.1501077
Sum	-1.1699423 × 10⁸
Variance	189.3122
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-98.0727	3646	0.3%
-81.7361	3613	0.3%
-82.9832	3597	0.3%
-108.8964	3527	0.3%
-79.7856	3123	0.2%
-86.2141	3123	0.2%
-111.0985	3119	0.2%
-82.2027	3117	0.2%
-90.5142	3113	0.2%
-73.098	3112	0.2%
Other values (959)	1263585	97.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-165.6723	1568	0.1%
-156.292	540	< 0.1%
-155.488	1032	0.1%
-155.3697	1527	0.1%
-153.994	12	< 0.1%
-124.4409	1043	0.1%
-124.2174	1547	0.1%
-124.1587	1031	0.1%
-124.1437	1526	0.1%
-123.9743	2036	0.2%

Value	Count	Frequency (%)
-67.9503	2080	0.2%
-68.5565	1014	0.1%
-69.2675	519	< 0.1%
-69.4828	2050	0.2%
-69.9576	537	< 0.1%
-69.9656	3107	0.2%
-70.1031	9	< 0.1%
-70.239	1036	0.1%
-70.3001	2090	0.2%
-70.3457	1527	0.1%

trans_num
Real number (ℝ)

UNIFORM UNIQUE

Distinct	1296675
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	648337

Minimum	0
Maximum	1296674
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	4.9 MiB

Quantile statistics

Minimum	0
5-th percentile	64833.7
Q1	324168.5
median	648337
Q3	972505.5
95-th percentile	1231840.3
Maximum	1296674
Range	1296674
Interquartile range (IQR)	648337

Descriptive statistics

Standard deviation	374317.97
Coefficient of variation (CV)	0.57735094
Kurtosis	-1.2
Mean	648337
Median Absolute Deviation (MAD)	324169
Skewness	-7.6039483 × 10^-19
Sum	8.4068238 × 10¹¹
Variance	1.4011395 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56438	1	< 0.1%
1014647	1	< 0.1%
134491	1	< 0.1%
351341	1	< 0.1%
479139	1	< 0.1%
395277	1	< 0.1%
426124	1	< 0.1%
224596	1	< 0.1%
565142	1	< 0.1%
1009881	1	< 0.1%
Other values (1296665)	1296665	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
1296674	1	< 0.1%
1296673	1	< 0.1%
1296672	1	< 0.1%
1296671	1	< 0.1%
1296670	1	< 0.1%
1296669	1	< 0.1%
1296668	1	< 0.1%
1296667	1	< 0.1%
1296666	1	< 0.1%
1296665	1	< 0.1%

unix_time
Real number (ℝ)

HIGH CORRELATION

Distinct	1274823
Distinct (%)	98.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3492436 × 10⁹

Minimum	1.325376 × 10⁹
Maximum	1.3718168 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	1.325376 × 10⁹
5-th percentile	1.328672 × 10⁹
Q1	1.3387507 × 10⁹
median	1.3492497 × 10⁹
Q3	1.3593854 × 10⁹
95-th percentile	1.3698306 × 10⁹
Maximum	1.3718168 × 10⁹
Range	46440799
Interquartile range (IQR)	20634633

Descriptive statistics

Standard deviation	12841278
Coefficient of variation (CV)	0.0095173904
Kurtosis	-1.0875405
Mean	1.3492436 × 10⁹
Median Absolute Deviation (MAD)	10358807
Skewness	0.0033779498
Sum	1.7495305 × 10¹⁵
Variance	1.6489843 × 10¹⁴
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1370177227	4	< 0.1%
1335110521	4	< 0.1%
1370050667	4	< 0.1%
1367602155	3	< 0.1%
1364686521	3	< 0.1%
1369587838	3	< 0.1%
1337306743	3	< 0.1%
1343668520	3	< 0.1%
1341944714	3	< 0.1%
1340650327	3	< 0.1%
Other values (1274813)	1296642	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1325376018	1	< 0.1%
1325376044	1	< 0.1%
1325376051	1	< 0.1%
1325376076	1	< 0.1%
1325376186	1	< 0.1%
1325376248	1	< 0.1%
1325376282	1	< 0.1%
1325376308	1	< 0.1%
1325376318	1	< 0.1%
1325376361	1	< 0.1%

Value	Count	Frequency (%)
1371816817	1	< 0.1%
1371816816	1	< 0.1%
1371816752	1	< 0.1%
1371816739	1	< 0.1%
1371816728	1	< 0.1%
1371816696	1	< 0.1%
1371816683	1	< 0.1%
1371816656	1	< 0.1%
1371816562	1	< 0.1%
1371816522	1	< 0.1%

merch_lat
Real number (ℝ)

HIGH CORRELATION

Distinct	1247805
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.537338

Minimum	19.027785
Maximum	67.510267
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	19.027785
5-th percentile	29.751653
Q1	34.733572
median	39.36568
Q3	41.957164
95-th percentile	46.00353
Maximum	67.510267
Range	48.482482
Interquartile range (IQR)	7.223592

Descriptive statistics

Standard deviation	5.1097884
Coefficient of variation (CV)	0.13259318
Kurtosis	0.79599391
Mean	38.537338
Median Absolute Deviation (MAD)	3.397536
Skewness	-0.18191543
Sum	49970403
Variance	26.109937
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.305966	4	< 0.1%
41.937796	4	< 0.1%
42.265012	4	< 0.1%
41.301611	4	< 0.1%
34.134994	4	< 0.1%
37.669788	4	< 0.1%
39.348185	4	< 0.1%
32.64469	4	< 0.1%
42.749184	4	< 0.1%
38.050673	4	< 0.1%
Other values (1247795)	1296635	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.027785	1	< 0.1%
19.027804	1	< 0.1%
19.029798	1	< 0.1%
19.031242	1	< 0.1%
19.032277	1	< 0.1%
19.033288	1	< 0.1%
19.034282	1	< 0.1%
19.034687	1	< 0.1%
19.035472	1	< 0.1%
19.036312	1	< 0.1%

Value	Count	Frequency (%)
67.510267	1	< 0.1%
67.441518	1	< 0.1%
67.397018	1	< 0.1%
67.188111	1	< 0.1%
67.064277	1	< 0.1%
66.835174	1	< 0.1%
66.682905	1	< 0.1%
66.67355	1	< 0.1%
66.664673	1	< 0.1%
66.659242	1	< 0.1%

merch_long
Real number (ℝ)

HIGH CORRELATION

Distinct	1275745
Distinct (%)	98.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-90.226465

Minimum	-166.67124
Maximum	-66.950902
Zeros	0
Zeros (%)	0.0%
Negative	1296675
Negative (%)	100.0%
Memory size	9.9 MiB

Quantile statistics

Minimum	-166.67124
5-th percentile	-119.33009
Q1	-96.897276
median	-87.438392
Q3	-80.236796
95-th percentile	-73.354218
Maximum	-66.950902
Range	99.72034
Interquartile range (IQR)	16.660479

Descriptive statistics

Standard deviation	13.771091
Coefficient of variation (CV)	-0.15262806
Kurtosis	1.8484792
Mean	-90.226465
Median Absolute Deviation (MAD)	8.227889
Skewness	-1.1469599
Sum	-1.169944 × 10⁸
Variance	189.64294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.116414	4	< 0.1%
-81.219189	4	< 0.1%
-74.618269	4	< 0.1%
-85.326323	3	< 0.1%
-84.890305	3	< 0.1%
-88.49309	3	< 0.1%
-84.100102	3	< 0.1%
-97.527227	3	< 0.1%
-85.3444	3	< 0.1%
-86.037494	3	< 0.1%
Other values (1275735)	1296642	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-166.671242	1	< 0.1%
-166.670132	1	< 0.1%
-166.669638	1	< 0.1%
-166.666179	1	< 0.1%
-166.664828	1	< 0.1%
-166.662888	1	< 0.1%
-166.661968	1	< 0.1%
-166.659277	1	< 0.1%
-166.657834	1	< 0.1%
-166.657174	1	< 0.1%

Value	Count	Frequency (%)
-66.950902	1	< 0.1%
-66.955996	1	< 0.1%
-66.95654	1	< 0.1%
-66.958659	1	< 0.1%
-66.958751	1	< 0.1%
-66.959178	1	< 0.1%
-66.961923	1	< 0.1%
-66.962913	1	< 0.1%
-66.963918	1	< 0.1%
-66.963975	1	< 0.1%

is_fraud
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	9.9 MiB

0	1289169
1	7506

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1296675
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring characters

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1296675	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	1296675	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1296675	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1289169	99.4%
1	7506	0.6%

Auto

Heatmap
Table

	amt	category	cc_num	city	gender	is_fraud	lat	long	merch_lat	merch_long	merchant	street	trans_date_trans_time	trans_num	unix_time	zip
amt	1.000	-0.295	-0.001	-0.002	0.000	0.000	0.012	-0.000	0.012	0.000	-0.012	0.008	0.001	0.001	0.001	0.001
category	-0.295	1.000	0.006	0.001	0.045	0.057	-0.009	-0.000	-0.009	-0.000	0.032	0.002	0.000	-0.000	0.000	0.002
cc_num	-0.001	0.006	1.000	0.000	0.051	0.006	-0.004	-0.013	-0.004	-0.013	-0.001	0.004	0.002	0.001	0.002	0.013
city	-0.002	0.001	0.000	1.000	0.057	0.005	-0.042	-0.067	-0.041	-0.067	-0.000	-0.023	-0.000	0.001	-0.000	0.076
gender	0.000	0.045	0.051	0.057	1.000	0.008	0.101	0.091	0.103	0.082	0.006	0.134	0.000	0.002	0.000	0.119
is_fraud	0.000	0.057	0.006	0.005	0.008	1.000	0.008	0.006	0.008	0.005	0.010	0.005	0.019	0.000	0.018	0.005
lat	0.012	-0.009	-0.004	-0.042	0.101	0.008	1.000	0.106	0.991	0.105	-0.002	-0.003	0.001	-0.001	0.001	-0.162
long	-0.000	-0.000	-0.013	-0.067	0.091	0.006	0.106	1.000	0.106	0.998	-0.001	0.074	-0.001	0.001	-0.001	-0.959
merch_lat	0.012	-0.009	-0.004	-0.041	0.103	0.008	0.991	0.106	1.000	0.104	-0.002	-0.005	0.001	-0.001	0.001	-0.162
merch_long	0.000	-0.000	-0.013	-0.067	0.082	0.005	0.105	0.998	0.104	1.000	-0.001	0.074	-0.001	0.001	-0.001	-0.957
merchant	-0.012	0.032	-0.001	-0.000	0.006	0.010	-0.002	-0.001	-0.002	-0.001	1.000	0.001	-0.001	-0.000	-0.001	0.001
street	0.008	0.002	0.004	-0.023	0.134	0.005	-0.003	0.074	-0.005	0.074	0.001	1.000	-0.001	-0.001	-0.001	-0.052
trans_date_trans_time	0.001	0.000	0.002	-0.000	0.000	0.019	0.001	-0.001	0.001	-0.001	-0.001	-0.001	1.000	-0.001	1.000	0.001
trans_num	0.001	-0.000	0.001	0.001	0.002	0.000	-0.001	0.001	-0.001	0.001	-0.000	-0.001	-0.001	1.000	-0.001	-0.001
unix_time	0.001	0.000	0.002	-0.000	0.000	0.018	0.001	-0.001	0.001	-0.001	-0.001	-0.001	1.000	-0.001	1.000	0.001
zip	0.001	0.002	0.013	0.076	0.119	0.005	-0.162	-0.959	-0.162	-0.957	0.001	-0.052	0.001	-0.001	0.001	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	trans_date_trans_time	cc_num	merchant	category	amt	gender	street	city	zip	lat	long	trans_num	unix_time	merch_lat	merch_long
0	0	2703186189652095	514	8	4.97	0	568	526	28654	36.0788	-81.1781	56438	1325376018	36.011293	-82.048315
1	1	630423337322	241	4	107.23	0	435	612	99160	48.8878	-118.2105	159395	1325376044	49.159047	-118.186462
2	2	38859492057661	390	0	220.11	1	602	468	83252	42.1808	-112.2620	818703	1325376051	43.150704	-112.154481
3	3	3534093764340240	360	2	45.00	1	930	84	59632	46.2306	-112.1138	544575	1325376076	47.034331	-112.561071
4	4	375534208663984	297	9	41.96	1	418	216	24433	38.4207	-79.4629	831111	1325376186	38.674999	-78.632459
5	5	4767265376804500	607	2	94.63	0	471	223	18917	40.3750	-75.2045	124696	1325376248	40.653382	-76.152667
6	6	30074693890476	534	3	44.54	0	882	351	67851	37.9931	-100.9893	667812	1325376282	37.162705	-100.153370
7	7	6011360759745864	107	2	71.65	1	224	236	22824	38.8432	-78.6003	552855	1325376308	38.948089	-78.540296
8	8	4922710831011201	250	9	4.27	0	685	474	15665	40.3359	-79.6607	1277329	1325376318	40.351813	-79.958146
9	9	2720830304681674	563	4	198.39	0	213	149	37040	36.5220	-87.3490	301740	1325376361	37.179198	-87.485381

	trans_date_trans_time	cc_num	merchant	category	amt	gender	street	city	zip	lat	long	trans_num	unix_time	merch_lat	merch_long
1296665	1274781	213193596103206	211	6	72.17	1	737	651	49775	45.7549	-84.4470	84021	1371816522	44.938461	-83.996234
1296666	1274782	4587657402165341815	274	5	7.30	0	635	638	60958	41.0646	-87.5917	281762	1371816562	40.556811	-88.092339
1296667	1274783	4822367783500458	221	13	19.71	1	960	317	33844	28.0758	-81.5929	268011	1371816656	27.465871	-81.511804
1296668	1274784	213141712584544	424	7	100.85	0	744	268	39073	32.1530	-90.1217	68597	1371816683	31.377697	-90.528450
1296669	1274785	4400011257587661852	598	9	37.38	0	483	584	68859	41.4972	-98.7858	782641	1371816696	41.728638	-99.039660
1296670	1274786	30263540414123	499	0	15.56	1	154	330	84735	37.7175	-112.4777	344658	1371816728	36.841266	-111.690765
1296671	1274787	6011149206456997	2	1	51.70	1	856	813	21790	39.2667	-77.5101	199896	1371816739	38.906881	-78.246528
1296672	1274788	3514865930894695	599	1	105.93	1	158	346	88325	32.9396	-105.8189	366013	1371816752	33.619513	-105.130529
1296673	1274789	2720012583106919	509	1	74.90	1	433	471	57756	43.3526	-102.5411	1086299	1371816816	42.788940	-103.241160
1296674	1274790	4292902571056973207	370	1	4.30	1	127	782	59871	45.8433	-113.8748	726622	1371816817	46.565983	-114.186110

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample